package com.itqf.dao.impl;

import com.itqf.dao.ItemDao;
import com.itqf.utils.C3P0Utils;
import org.apache.commons.dbutils.QueryRunner;

import java.sql.SQLException;

public class ItemDaoImpl implements ItemDao {
    @Override
    public void deleteItemByOid(String oid) throws SQLException {
        QueryRunner queryRunner = new QueryRunner(C3P0Utils.getDataSource());

        String sql = "delete from item where o_id = ?;";

        queryRunner.update(sql,oid);
    }
}
